www.loanperformer.com

Table of Contents (Online Help)

Debtors Balances Report

A debtor is an individual, business or any other entity that owes money to another entity/institution who has/have provided them with a service or good, or borrowed money from an institution.

In Loan Performer, the Debtors Balances Report displays the debtors balances due as at a particular date.

Note that this report will only display the debtors have been entered into the system under the menu Accounts/Purchases and Sale/Debtors and transactions conducted under Accounts/Purchases and Sale/Issue Invoices.

Both debtors whose obligations are outstanding and those who have cleared will appear on the Debtors Balances Report.

How to view the Debtors Balances Report

To view this report you go to Accounts/Purchases and Sales/Debtors Reports/Debtors Balances Report and a screen that looks as follows will appear:

• Reporting Date: In the date textbox enter the date until which the debtors balances should be reported, e.g., "06/10/2020".
• Debtors Analysis 1/2/3: Loan Performer allows you to view the balances for specific debtor's categories. Choose the analysis category from the drop-down boxes or tick the Check for all checkbox to include all categories in the report.  
• Currency: From the drop down list select the currency in which the report should appear, e.g., "UGX".
• From Branch: Choose the branch code from the drop-down or tick the Check for all checkbox to include all branches.
• From GL account: From the drop down menu, select the account number from which the Debtors Balances Report will start and in the till GL account option, enter the account on which the Debtors Balances Report is to stop or select the Check for all option to include all the GL accounts in the report.

• From Cost Centre:  From the drop down box, select the cost centre from which to generate Debtors Balances Report and in the till Cost Centre, enter the date on which the report will stop. When the Check for all options is selected, then Breakdown per Accounts report will be generated for all Cost Centres.

• From Debtor:  From the drop down box, select the Debtor from which to generate Debtors Balances Report and in the till Debtor Centre, enter the date on which the report will stop. When the Check for all options is selected, then Debtors Balances Report will be generated for all Debtors.
• Tenants only: When this option is selected, the report will only display the institution's tenants. The tenants should have been entered under the menu Clients/Individual Clients/Tenant.
• Non Tenants only: When this option is selected, the report will only display the institution's debtors who aren't tenants as well as seen below. The tenants should have been entered under the menu Clients/Individual Clients/Tenant.
• Group by: From the drop down menu,choose the order in which you want your report to display. There are two options: by Debtor ID to display the report in ascending order or by Debtor Name - to display in alphabetical order.

Select any other required additional options or use the default selections. For additional information on these options you can refer to Accounting Report Formats.

Click on the OK button to view the report which will look similar to the following:

Click on the Close button to exit the menu.

Related Topics

Contact LPF live support for more information
This service requires an Internet connection.